CREATE TABLE [dbo].[Security_Filters]
(
[SECURITY_GROUP] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Security_Filters_SECURITY_GROUP] DEFAULT (''),
[SECURITY_MODE] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Security_Filters_SECURITY_MODE] DEFAULT (''),
[TABLE_NAME] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Security_Filters_TABLE_NAME] DEFAULT (''),
[TABLE_ACCESSIBLE] [bit] NOT NULL CONSTRAINT [DF_Security_Filters_TABLE_ACCESSIBLE] DEFAULT ((0)),
[TABLE_FILTER] [varchar] (254) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DESCRIPTION] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Security_Filters_DESCRIPTION] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Security_Filters] ADD CONSTRAINT [PK_Security_Filters] PRIMARY KEY NONCLUSTERED ([SECURITY_GROUP], [SECURITY_MODE], [TABLE_NAME]) ON [PRIMARY]
GO
GRANT REFERENCES ON [dbo].[Security_Filters] TO [IMIS]
GRANT SELECT ON [dbo].[Security_Filters] TO [IMIS]
GRANT INSERT ON [dbo].[Security_Filters] TO [IMIS]
GRANT DELETE ON [dbo].[Security_Filters] TO [IMIS]
GRANT UPDATE ON [dbo].[Security_Filters] TO [IMIS]
GO